SQL для тестировщика

Дана следующая таблица:

| OrderID | CustomerID |  OrderDate | TotalAmount |
|---------|------------|------------|-------------|
|    1    |    101     | 2022-05-15 |    500      |
|    2    |    102     | 2022-06-20 |    750      |
|    3    |    103     | 2022-06-25 |   1000      |
|    4    |    101     | 2022-07-10 |    300      |
|    5    |    104     | 2022-08-05 |    900      |

Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A)

SELECT CustomerID, MAX(TotalAmount) FROM Orders

SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)

SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)

D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID

www.tg-me.com/jp/SQL для тестировщика/com.sql_for_qa/108

2.2K viewsJun 15, 2023 at 13:56

tg-me.com/sql_for_qa/108

Create: 2023-06-15
Last Update: 2025-07-01 21:50:00

Дана следующая таблица:

| OrderID | CustomerID | OrderDate | TotalAmount | |---------|------------|------------|-------------| | 1 | 101 | 2022-05-15 | 500 | | 2 | 102 | 2022-06-20 | 750 | | 3 | 103 | 2022-06-25 | 1000 | | 4 | 101 | 2022-07-10 | 300 | | 5 | 104 | 2022-08-05 | 900 |Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?

A) SELECT CustomerID, MAX(TotalAmount) FROM OrdersB) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)C) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/108

SQL для тестировщика Telegram | DID YOU KNOW?

That strategy is the acquisition of a value-priced company by a growth company. Using the growth company's higher-priced stock for the acquisition can produce outsized revenue and earnings growth. Even better is the use of cash, particularly in a growth period when financial aggressiveness is accepted and even positively viewed.he key public rationale behind this strategy is synergy - the 1+1=3 view. In many cases, synergy does occur and is valuable. However, in other cases, particularly as the strategy gains popularity, it doesn't. Joining two different organizations, workforces and cultures is a challenge. Simply putting two separate organizations together necessarily creates disruptions and conflicts that can undermine both operations.

Telegram Gives Up On Crypto Blockchain Project

Durov said on his Telegram channel today that the two and a half year blockchain and crypto project has been put to sleep. Ironically, after leaving Russia because the government wanted his encryption keys to his social media firm, Durov’s cryptocurrency idea lost steam because of a U.S. court. “The technology we created allowed for an open, free, decentralized exchange of value and ideas. TON had the potential to revolutionize how people store and transfer funds and information,” he wrote on his channel. “Unfortunately, a U.S. court stopped TON from happening.”